﻿CREATE TRIGGER [TRG_InsertActivityOnCustomer] ON [dbo].[tblCustomer] 
FOR INSERT
AS
set nocount on
insert into tblAccountActivity ( CustomerID, KeyID, ActivityDate, ActivityCode, Agent )
select CustomerID, CustomerID, GETDATE(), '1', dbo.CurrentUserID()
from inserted